Q This is your opportunity to show that you have mastered the Excel skills in this course, and create charts and tables to support your Topic Proposal. You do not have to update your Word report at this time, you only need to create the tables/charts that you will use in the final version of the report. You will be graded only on your Excel work, using the Skill list below, which are mapped to the grading rubrics for this assignment. Remember to use the Excel Skill list for grading guidance.docx Actions Rubric Sig. Assignment: Excel Data Analysis Sig. Assignment: Excel Data Analysis Criteria Ratings Pts This criterion is linked to a Learning OutcomeFormulas and Functions 25 to >20.0 pts Professional All formulas are correct and are effectively constructed. There is a variety of appropriately used functions 20 to >10.0 pts Approaching Professional Formulas are mostly correct but not always constructed in the most effective manner.Opportunities for functions were not fully utilized. 10 to >0 pts Needs Imporvement Some formulas are missing or incorrect; or only numbers were entered.Functions are not included 25 pts This criterion is linked to a Learning OutcomeCharts 25 to >20.0 pts Professional Appropriate Chart(s) created correctly with clear labeling 20 to >10.0 pts Approaching Professional Appropriate Chart(s) created but the data was incorrect or incomplete; labeling was incomplete or unclear 10 to >0 pts Needs Improvement Missing Charts or charts were done haphazardly 25 pts This criterion is linked to a Learning OutcomeFormatting 25 to >20.0 pts Professional Formatting is attractive, clear and appropriate. 20 to >10.0 pts Approaching Professional Adequately formatted but difficult to read or unattractive. 10 to >0 pts Needs Improvement Inadequate or no formatting. 25 pts This criterion is linked to a Learning OutcomeContent 25 to >20.0 pts Professional Data applies directly to the area of concern and is from a reputable shource 20 to >10.0 pts Approaching Professional Data can be only loosely applied to the area of concern, or the source is questionable 10 to >0 pts Needs Improvement Data does not apply to the area of concern or the data was not clearly from a reasonable source 25 pts Total Points: 100 PreviousNext

Q SKILL WHAT TO LOOK FOR IN MY SUBMISSION FORMULAS AND FUNCTIONS Basic functions ( SUM, AVG, MAX, etc. ) Formulas with math operations Formulas/functions with relative and absolute cell referencing Formulas/functions using cell ranges Formulas/functions referencing data in multiple worksheets Extra: Complex function not covered in the material Cell alignment, styles, font colors, etc. Sorting/filtering CHARTS Column/bar or pie chart Customized Use of different chart styles Extra: Stacked bar chart FORMATTING Number formatting ( currency, percentages, dates, comma styles, etc.) Conditional formatting Worksheets/Tables with Themes Rotate text Print formatting with Headers/footers using autotext and alignment Print pagination with appropriate breaks and page numbering Spell checking